At 18:33 +0300 on 29/06/1999, Leon wrote:
> adb=> EXPLAIN SELECT COUNT(*) FROM atable WHERE atable.cfield =
>btable.cfield
> AND atable.afield<10;
...
>
> adb=> EXPLAIN SELECT COUNT(*) FROM atable WHERE atable.cfield =
>btable.cfield
> AND atable.afield>100;
Hey, shouldn't these be:
SELECT COUNT(*)
FROM atable, btable <----- Note this!
WHERE atable.cfield = btable.cfield
AND ....
I'm not sure that when the other table is implicit, the optimizer checks
the statistics of the btable on time.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma